// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License.  You may obtain a copy of the License at
//
//   http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.


suite("test_cast_to_decimal128i_38_19_from_str") {

    // This test case is generated from the correspoinding be UT test case,
    // update this case if the correspoinding be UT test case is updated,
    // e.g.: ../run-be-ut.sh --run --filter=FunctionCastToDecimalTest.* --gen_regression_case
    sql "drop table if exists test_cast_to_decimal128i_38_19_from_str_15_nullable;"
    sql "create table test_cast_to_decimal128i_38_19_from_str_15_nullable(f1 int, f2 string) properties('replication_num'='1');"
    sql """insert into test_cast_to_decimal128i_38_19_from_str_15_nullable values (0, "0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(1, "-0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(2, "0"),(3, "1"),(4, "9"),(5, "999999999999999999"),(6, "9000000000000000000"),(7, "9000000000000000001"),(8, "9999999999999999998"),(9, "9999999999999999999"),(10, "0."),(11, "1."),(12, "9."),(13, "999999999999999999."),(14, "9000000000000000000."),(15, "9000000000000000001."),(16, "9999999999999999998."),(17, "9999999999999999999."),(18, "-0"),(19, "-1"),
      (20, "-9"),(21, "-999999999999999999"),(22, "-9000000000000000000"),(23, "-9000000000000000001"),(24, "-9999999999999999998"),(25, "-9999999999999999999"),(26, "-0."),(27, "-1."),(28, "-9."),(29, "-999999999999999999."),(30, "-9000000000000000000."),(31, "-9000000000000000001."),(32, "-9999999999999999998."),(33, "-9999999999999999999."),(34, ".00000000000000000004"),(35, ".00000000000000000014"),(36, ".00000000000000000094"),(37, ".09999999999999999994"),(38, ".90000000000000000004"),(39, ".90000000000000000014"),
      (40, ".99999999999999999984"),(41, ".99999999999999999994"),(42, ".00000000000000000005"),(43, ".00000000000000000015"),(44, ".00000000000000000095"),(45, ".09999999999999999995"),(46, ".90000000000000000005"),(47, ".90000000000000000015"),(48, ".99999999999999999985"),(49, ".99999999999999999994"),(50, "-.00000000000000000004"),(51, "-.00000000000000000014"),(52, "-.00000000000000000094"),(53, "-.09999999999999999994"),(54, "-.90000000000000000004"),(55, "-.90000000000000000014"),(56, "-.99999999999999999984"),(57, "-.99999999999999999994"),(58, "-.00000000000000000005"),(59, "-.00000000000000000015"),
      (60, "-.00000000000000000095"),(61, "-.09999999999999999995"),(62, "-.90000000000000000005"),(63, "-.90000000000000000015"),(64, "-.99999999999999999985"),(65, "-.99999999999999999994"),(66, "00000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(67, "00000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(68, "00000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(69, "00999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(70, "09000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(71, "09000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(72, "09999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(73, "09999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(74, "10000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(75, "10000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(76, "10000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(77, "10999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(78, "19000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(79, "19000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (80, "19999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(81, "19999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(82, "90000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(83, "90000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(84, "90000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(85, "90999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(86, "99000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(87, "99000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(88, "99999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(89, "99999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(90, "9999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(91, "9999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(92, "9999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(93, "9999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(94, "9999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(95, "9999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(96, "9999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(97, "9999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(98, "90000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(99, "90000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (100, "90000000000000000000000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(101, "90000000000000000000999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(102, "90000000000000000009000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(103, "90000000000000000009000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(104, "90000000000000000009999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(105, "90000000000000000009999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(106, "90000000000000000010000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(107, "90000000000000000010000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(108, "90000000000000000010000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(109, "90000000000000000010999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(110, "90000000000000000019000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(111, "90000000000000000019000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(112, "90000000000000000019999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(113, "90000000000000000019999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(114, "99999999999999999980000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(115, "99999999999999999980000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(116, "99999999999999999980000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(117, "99999999999999999980999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(118, "99999999999999999989000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(119, "99999999999999999989000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (120, "99999999999999999989999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(121, "99999999999999999989999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(122, "99999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(123, "99999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(124, "99999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(125, "99999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(126, "99999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(127, "99999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(128, "99999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(129, "99999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(130, "00000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(131, "00000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(132, "00000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(133, "00999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(134, "09000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(135, "09000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(136, "09999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(137, "09999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(138, "10000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(139, "10000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (140, "10000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(141, "10999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(142, "19000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(143, "19000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(144, "19999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(145, "19999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(146, "90000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(147, "90000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(148, "90000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(149, "90999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(150, "99000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(151, "99000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(152, "99999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(153, "99999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(154, "9999999999999999990000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(155, "9999999999999999990000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(156, "9999999999999999990000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(157, "9999999999999999990999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(158, "9999999999999999999000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(159, "9999999999999999999000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (160, "9999999999999999999999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(161, "9999999999999999999999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(162, "90000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(163, "90000000000000000000000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(164, "90000000000000000000000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(165, "90000000000000000000999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(166, "90000000000000000009000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(167, "90000000000000000009000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(168, "90000000000000000009999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(169, "90000000000000000009999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(170, "90000000000000000010000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(171, "90000000000000000010000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(172, "90000000000000000010000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(173, "90000000000000000010999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(174, "90000000000000000019000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(175, "90000000000000000019000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(176, "90000000000000000019999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(177, "90000000000000000019999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(178, "99999999999999999980000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(179, "99999999999999999980000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (180, "99999999999999999980000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(181, "99999999999999999980999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(182, "99999999999999999989000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(183, "99999999999999999989000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(184, "99999999999999999989999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(185, "99999999999999999989999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(186, "99999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(187, "99999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(188, "99999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(189, "99999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(190, "99999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(191, "99999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(192, "99999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(193, "99999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(194, "-00000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(195, "-00000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(196, "-00000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(197, "-00999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(198, "-09000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(199, "-09000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (200, "-09999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(201, "-09999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(202, "-10000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(203, "-10000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(204, "-10000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(205, "-10999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(206, "-19000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(207, "-19000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(208, "-19999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(209, "-19999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(210, "-90000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(211, "-90000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(212, "-90000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(213, "-90999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(214, "-99000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(215, "-99000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(216, "-99999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(217, "-99999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(218, "-9999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(219, "-9999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (220, "-9999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(221, "-9999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(222, "-9999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(223, "-9999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(224, "-9999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(225, "-9999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(226, "-90000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(227, "-90000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(228, "-90000000000000000000000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(229, "-90000000000000000000999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(230, "-90000000000000000009000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(231, "-90000000000000000009000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(232, "-90000000000000000009999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(233, "-90000000000000000009999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(234, "-90000000000000000010000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(235, "-90000000000000000010000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(236, "-90000000000000000010000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(237, "-90000000000000000010999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(238, "-90000000000000000019000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(239, "-90000000000000000019000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (240, "-90000000000000000019999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(241, "-90000000000000000019999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(242, "-99999999999999999980000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(243, "-99999999999999999980000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(244, "-99999999999999999980000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(245, "-99999999999999999980999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(246, "-99999999999999999989000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(247, "-99999999999999999989000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(248, "-99999999999999999989999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(249, "-99999999999999999989999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(250, "-99999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(251, "-99999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(252, "-99999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(253, "-99999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(254, "-99999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(255, "-99999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(256, "-99999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(257, "-99999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(258, "-00000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(259, "-00000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (260, "-00000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(261, "-00999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(262, "-09000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(263, "-09000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(264, "-09999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(265, "-09999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(266, "-10000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(267, "-10000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(268, "-10000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(269, "-10999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(270, "-19000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(271, "-19000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(272, "-19999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(273, "-19999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(274, "-90000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(275, "-90000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(276, "-90000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(277, "-90999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(278, "-99000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(279, "-99000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (280, "-99999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(281, "-99999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(282, "-9999999999999999990000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(283, "-9999999999999999990000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(284, "-9999999999999999990000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(285, "-9999999999999999990999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(286, "-9999999999999999999000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(287, "-9999999999999999999000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(288, "-9999999999999999999999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(289, "-9999999999999999999999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(290, "-90000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(291, "-90000000000000000000000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(292, "-90000000000000000000000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(293, "-90000000000000000000999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(294, "-90000000000000000009000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(295, "-90000000000000000009000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(296, "-90000000000000000009999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(297, "-90000000000000000009999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(298, "-90000000000000000010000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(299, "-90000000000000000010000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (300, "-90000000000000000010000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(301, "-90000000000000000010999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(302, "-90000000000000000019000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(303, "-90000000000000000019000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(304, "-90000000000000000019999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(305, "-90000000000000000019999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(306, "-99999999999999999980000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(307, "-99999999999999999980000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(308, "-99999999999999999980000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(309, "-99999999999999999980999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(310, "-99999999999999999989000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(311, "-99999999999999999989000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(312, "-99999999999999999989999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(313, "-99999999999999999989999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(314, "-99999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(315, "-99999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(316, "-99999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(317, "-99999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(318, "-99999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(319, "-99999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (320, "-99999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(321, "-99999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100")
      ,(322, null);
    """

    sql "set enable_strict_cast=true;"
    qt_sql_15_strict 'select f1, cast(f2 as decimalv3(38, 19)) from test_cast_to_decimal128i_38_19_from_str_15_nullable order by 1;'

    sql "set enable_strict_cast=false;"
    qt_sql_15_non_strict 'select f1, cast(f2 as decimalv3(38, 19)) from test_cast_to_decimal128i_38_19_from_str_15_nullable order by 1;'

    sql "drop table if exists test_cast_to_decimal128i_38_19_from_str_15_not_nullable;"
    sql "create table test_cast_to_decimal128i_38_19_from_str_15_not_nullable(f1 int, f2 string) properties('replication_num'='1');"
    sql """insert into test_cast_to_decimal128i_38_19_from_str_15_not_nullable values (0, "0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(1, "-0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(2, "0"),(3, "1"),(4, "9"),(5, "999999999999999999"),(6, "9000000000000000000"),(7, "9000000000000000001"),(8, "9999999999999999998"),(9, "9999999999999999999"),(10, "0."),(11, "1."),(12, "9."),(13, "999999999999999999."),(14, "9000000000000000000."),(15, "9000000000000000001."),(16, "9999999999999999998."),(17, "9999999999999999999."),(18, "-0"),(19, "-1"),
      (20, "-9"),(21, "-999999999999999999"),(22, "-9000000000000000000"),(23, "-9000000000000000001"),(24, "-9999999999999999998"),(25, "-9999999999999999999"),(26, "-0."),(27, "-1."),(28, "-9."),(29, "-999999999999999999."),(30, "-9000000000000000000."),(31, "-9000000000000000001."),(32, "-9999999999999999998."),(33, "-9999999999999999999."),(34, ".00000000000000000004"),(35, ".00000000000000000014"),(36, ".00000000000000000094"),(37, ".09999999999999999994"),(38, ".90000000000000000004"),(39, ".90000000000000000014"),
      (40, ".99999999999999999984"),(41, ".99999999999999999994"),(42, ".00000000000000000005"),(43, ".00000000000000000015"),(44, ".00000000000000000095"),(45, ".09999999999999999995"),(46, ".90000000000000000005"),(47, ".90000000000000000015"),(48, ".99999999999999999985"),(49, ".99999999999999999994"),(50, "-.00000000000000000004"),(51, "-.00000000000000000014"),(52, "-.00000000000000000094"),(53, "-.09999999999999999994"),(54, "-.90000000000000000004"),(55, "-.90000000000000000014"),(56, "-.99999999999999999984"),(57, "-.99999999999999999994"),(58, "-.00000000000000000005"),(59, "-.00000000000000000015"),
      (60, "-.00000000000000000095"),(61, "-.09999999999999999995"),(62, "-.90000000000000000005"),(63, "-.90000000000000000015"),(64, "-.99999999999999999985"),(65, "-.99999999999999999994"),(66, "00000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(67, "00000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(68, "00000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(69, "00999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(70, "09000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(71, "09000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(72, "09999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(73, "09999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(74, "10000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(75, "10000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(76, "10000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(77, "10999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(78, "19000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(79, "19000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (80, "19999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(81, "19999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(82, "90000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(83, "90000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(84, "90000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(85, "90999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(86, "99000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(87, "99000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(88, "99999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(89, "99999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(90, "9999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(91, "9999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(92, "9999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(93, "9999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(94, "9999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(95, "9999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(96, "9999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(97, "9999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(98, "90000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(99, "90000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (100, "90000000000000000000000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(101, "90000000000000000000999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(102, "90000000000000000009000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(103, "90000000000000000009000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(104, "90000000000000000009999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(105, "90000000000000000009999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(106, "90000000000000000010000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(107, "90000000000000000010000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(108, "90000000000000000010000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(109, "90000000000000000010999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(110, "90000000000000000019000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(111, "90000000000000000019000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(112, "90000000000000000019999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(113, "90000000000000000019999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(114, "99999999999999999980000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(115, "99999999999999999980000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(116, "99999999999999999980000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(117, "99999999999999999980999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(118, "99999999999999999989000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(119, "99999999999999999989000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (120, "99999999999999999989999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(121, "99999999999999999989999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(122, "99999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(123, "99999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(124, "99999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(125, "99999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(126, "99999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(127, "99999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(128, "99999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(129, "99999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(130, "00000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(131, "00000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(132, "00000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(133, "00999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(134, "09000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(135, "09000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(136, "09999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(137, "09999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(138, "10000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(139, "10000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (140, "10000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(141, "10999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(142, "19000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(143, "19000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(144, "19999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(145, "19999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(146, "90000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(147, "90000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(148, "90000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(149, "90999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(150, "99000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(151, "99000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(152, "99999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(153, "99999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(154, "9999999999999999990000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(155, "9999999999999999990000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(156, "9999999999999999990000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(157, "9999999999999999990999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(158, "9999999999999999999000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(159, "9999999999999999999000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (160, "9999999999999999999999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(161, "9999999999999999999999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(162, "90000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(163, "90000000000000000000000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(164, "90000000000000000000000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(165, "90000000000000000000999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(166, "90000000000000000009000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(167, "90000000000000000009000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(168, "90000000000000000009999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(169, "90000000000000000009999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(170, "90000000000000000010000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(171, "90000000000000000010000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(172, "90000000000000000010000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(173, "90000000000000000010999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(174, "90000000000000000019000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(175, "90000000000000000019000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(176, "90000000000000000019999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(177, "90000000000000000019999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(178, "99999999999999999980000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(179, "99999999999999999980000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (180, "99999999999999999980000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(181, "99999999999999999980999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(182, "99999999999999999989000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(183, "99999999999999999989000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(184, "99999999999999999989999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(185, "99999999999999999989999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(186, "99999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(187, "99999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(188, "99999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(189, "99999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(190, "99999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(191, "99999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(192, "99999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(193, "99999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(194, "-00000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(195, "-00000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(196, "-00000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(197, "-00999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(198, "-09000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(199, "-09000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (200, "-09999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(201, "-09999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(202, "-10000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(203, "-10000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(204, "-10000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(205, "-10999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(206, "-19000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(207, "-19000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(208, "-19999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(209, "-19999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(210, "-90000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(211, "-90000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(212, "-90000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(213, "-90999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(214, "-99000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(215, "-99000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(216, "-99999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(217, "-99999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(218, "-9999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(219, "-9999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (220, "-9999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(221, "-9999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(222, "-9999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(223, "-9999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(224, "-9999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(225, "-9999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(226, "-90000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(227, "-90000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(228, "-90000000000000000000000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(229, "-90000000000000000000999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(230, "-90000000000000000009000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(231, "-90000000000000000009000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(232, "-90000000000000000009999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(233, "-90000000000000000009999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(234, "-90000000000000000010000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(235, "-90000000000000000010000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(236, "-90000000000000000010000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(237, "-90000000000000000010999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(238, "-90000000000000000019000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(239, "-90000000000000000019000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (240, "-90000000000000000019999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(241, "-90000000000000000019999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(242, "-99999999999999999980000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(243, "-99999999999999999980000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(244, "-99999999999999999980000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(245, "-99999999999999999980999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(246, "-99999999999999999989000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(247, "-99999999999999999989000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(248, "-99999999999999999989999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(249, "-99999999999999999989999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(250, "-99999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(251, "-99999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(252, "-99999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(253, "-99999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(254, "-99999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(255, "-99999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(256, "-99999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(257, "-99999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(258, "-00000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(259, "-00000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (260, "-00000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(261, "-00999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(262, "-09000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(263, "-09000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(264, "-09999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(265, "-09999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(266, "-10000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(267, "-10000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(268, "-10000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(269, "-10999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(270, "-19000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(271, "-19000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(272, "-19999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(273, "-19999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(274, "-90000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(275, "-90000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(276, "-90000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(277, "-90999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(278, "-99000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(279, "-99000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (280, "-99999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(281, "-99999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(282, "-9999999999999999990000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(283, "-9999999999999999990000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(284, "-9999999999999999990000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(285, "-9999999999999999990999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(286, "-9999999999999999999000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(287, "-9999999999999999999000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(288, "-9999999999999999999999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(289, "-9999999999999999999999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(290, "-90000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(291, "-90000000000000000000000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(292, "-90000000000000000000000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(293, "-90000000000000000000999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(294, "-90000000000000000009000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(295, "-90000000000000000009000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(296, "-90000000000000000009999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(297, "-90000000000000000009999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(298, "-90000000000000000010000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(299, "-90000000000000000010000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (300, "-90000000000000000010000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(301, "-90000000000000000010999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(302, "-90000000000000000019000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(303, "-90000000000000000019000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(304, "-90000000000000000019999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(305, "-90000000000000000019999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(306, "-99999999999999999980000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(307, "-99999999999999999980000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(308, "-99999999999999999980000000000000000009500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(309, "-99999999999999999980999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(310, "-99999999999999999989000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(311, "-99999999999999999989000000000000000001500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(312, "-99999999999999999989999999999999999998500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(313, "-99999999999999999989999999999999999999500000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(314, "-99999999999999999990000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(315, "-99999999999999999990000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(316, "-99999999999999999990000000000000000009400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(317, "-99999999999999999990999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(318, "-99999999999999999999000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(319, "-99999999999999999999000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (320, "-99999999999999999999999999999999999998400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(321, "-99999999999999999999999999999999999999400000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100");
    """

    sql "set enable_strict_cast=true;"
    qt_sql_15_strict 'select f1, cast(f2 as decimalv3(38, 19)) from test_cast_to_decimal128i_38_19_from_str_15_not_nullable order by 1;'

    sql "set enable_strict_cast=false;"
    qt_sql_15_non_strict 'select f1, cast(f2 as decimalv3(38, 19)) from test_cast_to_decimal128i_38_19_from_str_15_not_nullable order by 1;'

}